2015-05-01 - 18948.100 - Enhancement - EMEA - Retail and Intercompany #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
18948.100 - EMEA - Retail and Intercompany
Purpose
Need to exclude/include the following Intercompany customers from all BEx Queries:
1013005
1013792
1013793
1013794
1014751
1016334
Admin Info
Purpose
|
Need to exclude the Intercompany customers from all BEx Queries.
|
Requested By
|
Mark G
|
Spec Created By
|
Naveen G
|
Spec Created Date
|
04/05/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
BEx Queries & Intercompany Customers attached.
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
08
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
08
|
5
|
Unit test in QUA
|
04
|
6
|
Other activity
|
04
|
|
TOTAL
|
50
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email from Mark G on 05/01/2015:
I have assigned ticket 18948.100 to you, which includes some Retail and Intercompany changes from our EMEA region. This should be prioritized behind any BPC work that Greg assigns to you.
Please let me know if you have any questions.
1. Identify All BW Sources leveraging Intercompany Exclusions/Inclusions:
a. Global Analysis Sources & EMEA Analysis Sources.
b. Reports / Scorecard.
2. Exclude the Following Retail Customers from non Retail / Intercompany sources:
a. 1013005
b. 1013792
c. 1013793
d. 1013794
e. 1014751
f. 1016334
3. Add the same list to any Retail /Intercompany source.
In Scope:
Need to exclude new Intercompany Customers 1013005, 1013792, 1013793, 1013794, 1014751 & 1016334
from all the BEx queries in BPD(BW 7.3 Development) and transport the requests to BPQ & BPP.
Out of Scope:
None
Solution Summary
1. Create an open BEx transport request in BPD.
2. Exclude new Intercompany Customers for 0CUSTOMER (or) 0SOLD_TO infoobjects in the BEx filter section.
3. Collect all the queries for an infoprovider into one open transport request.
4. Transport it to BPQ for testing and move it to BPP after successful testing.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check whether the changes are collected into the transport request.
|
All the changes should be collected into the transport request.
|
2
|
Check if all the Intercompany Customers(52) are excluded in BEx queries.
|
All Intercompany customers(52) should be excluded in BEx queries.
|
3
|
Check if all the changes meet the BEx QA Standards as per checklist.
|
BEx Query should pass all the QA test cases as in checklist.
|
Solution Details
1. Create an Open transport request in BPD(BW 7.3 Development).
2. Exclude new Intercompany Customers 1013005, 1013792, 1013793, 1013794, 1014751 & 1016334
for 0CUSTOMER (or) 0SOLD_TO infoobject in the BEx filter section.
3. Collect all the queries for an infoprovider into the open transport request.
4. Transport it to BPQ(BW 7.3 Quality) for testing and move it to BPP(BW 7.3 Production) after successful testing.
5. The list of all BEx Queries in which EMEA Retail IC customers are excluded or included are attached here for reference:
Global BEx Queries for Intercompany Exclusion 05-01-2015.xls
Regional BEx Queries for Intercompany Exclusion 05-01-2015.xlsx
6. The list of all updated Intercompany Customers(52) is attached here for reference:
InterCompany Customers 05-01-2015.txt
Issues
1. Some of the BEx queries need the intercompany customers to be included as specified in the attached spreadsheet.
2. All Exclusions/Inclusions need to be manually updated to each BEx query and cannot be updated globally.